--HEADER added EnterPhaseEnd and ExitPhaseStart to Analytics.Investment

IF NOT EXISTS(SELECT * FROM sys.columns 
        WHERE [name] = N'ExitPhaseStart' AND [object_id] = OBJECT_ID(N'[Analytics].[Investment]'))
BEGIN
	ALTER TABLE [Analytics].[Investment]
	ADD [ExitPhaseStart] DATETIME2 NULL
END

GO

IF NOT EXISTS(SELECT * FROM sys.columns 
        WHERE [name] = N'EnterPhaseEnd' AND [object_id] = OBJECT_ID(N'[Analytics].[Investment]'))
BEGIN
	ALTER TABLE [Analytics].[Investment]
	ADD [EnterPhaseEnd] DATETIME2 NULL
END